MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Artist Nationality = 746

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Medium, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
206487 21.36.137 0 0 333831 Drawings and Prints 11 Book 97 The History of England, From the Invasion of Julius Cæsar to the Revolution in 1688           Author|Publisher|Printer|Dedicatee 983   David Hume|Robert Bowyer|Thomas Bensley|George III, King of Great Britain and Ireland British, Edinburgh, Scotland 1711–1776 Edinburgh|British, Portsmouth 1758–1834 Byfleet, Surrey|London|British, London 1738–1820 Windsor   Hume, David|Bowyer, Robert|Bensley, Thomas|George III, King of Great Britain and Ireland 17324 British, Scottish|British|British|British 746 1711 |1758 |1759 |1738 1776 |1834 |1835 |1820 1806 1806 1806 Illustrations: engraving 28942 18 1/4 x 14 3/8 x 2 3/4 in. (46.3 x 36.5 x 7cm) Jacob S. Rogers Bequest, 1921, transferred from the Library                       Books 442   Metropolitan Museum of Art, New York, NY 1
218618 54.592.1 0 0 346125 Drawings and Prints 11 Book 97 A Poetic Survey Round Birmingham           Author|Publisher|Engraver|Engraver 1495 Written and published by James Bisset|Swinney and Hawkins|Francis Eginton|Thomas Hancock British (born Scotland), ca. 1762–1832|Birmingham|British, 1775–1823|British, active Birmingham 1800–1805   Bisset, James|Swinney and Hawkins|Eginton, Francis|Hancock, Thomas 21990 British, Scottish|British|British|British 746 1762 |1750 |1775 |1750 1832 |1850 |1823 |1850 1800 1800 1800 Illustrations: engraving 28942 9 3/16 x 5 13/16 x 11/16 in. (23.4 x 14.7 x 1.8 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1954   Birmingham 86                   Books 442   Metropolitan Museum of Art, New York, NY 1
224923 1972.632.7 0 0 352517 Drawings and Prints 11 Book 97 The Little White Town of Never-Weary           Illustrator|Publisher|Artist|Printer 2843 Photographs by Jessie Marion King|George G. Harrap & Co. Ltd.|J. Bruce Cameron|The Complete Press British, New Kilpatrick, Dunbartonshire, Scotland 1875–1949 Kirkcudbright|London|British, active early 20th century|London of Messrs. T. & R. Annan King, Jessie Marion|Harrap, George G. & Co. Ltd.|Cameron, J. Bruce|The Complete Press 26587 British, Scottish|British|British|British 746 1875 |1880 |1900 |1850 1949 |1999 |1950 |1950 [1917] 1917 1917 Illustrations: reproduced wash drawings and photographs; wood engravings 35466 10 x 7 11/16 x 1 1/8 in. (25.4 x 19.5 x 2.9 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1972                       Books 442   Metropolitan Museum of Art, New York, NY 1
228596 53.686.3 0 0 356232 Drawings and Prints 11 Book 97 Beauty's Costume: A series of female figures in the dresses of all times and nations           Author|Publisher|Etcher|Printer 3351   Leitch Ritchie|Longman, Orme, Brown, Green and Longman|Charles Heath, the elder|J. Haddon British, Greenock, Scotland 1800–1865 London|London|British, London 1785–1848 London|London   Ritchie, Leitch|Longman, Orme, Brown, Green and Longman|Heath, Charles the elder|Haddon, J. 29132 British, Scottish|British|British|British 746 1800 |1800 |1785 |1800 1865 |1900 |1848 |1899 1836 1836 1836 Illustrations: engravings 33775 11 7/16 x 8 11/16 x 3/8 in. (29 x 22 x 1 cm) Gift of Harry G. Friedman, 1953                       Books 442   Metropolitan Museum of Art, New York, NY 1
228784 66.723.1 0 0 356422 Drawings and Prints 11 Book 97 Narrative of a second voyage in search of a north-west passage and of a residence in the arctic regions during the years 1829 - 1833           Author|Publisher|Dedicatee|Lithographer 3375 Written and illustrated by Sir John Ross|A. W. Webster|William IV, King of the United Kingdom of Great Britain and Ireland|Charles Walter Radclyffe British, Inch, Scotland 1777–1856 London|London|British, 1765–1837|British, Birmingham 1807–1903 Birmingham   Ross, John Sir|Webster, A. W.|William IV, King of the United Kingdom of Great Britain and Ireland|Radclyffe, Charles Walter 29254 British, Scottish|British|British|British 746 1777 |1800 |1765 |1807 1856 |1900 |1837 |1903 1835 1835 1835 Illustrations: lithography 28996 12 3/8 × 9 5/8 × 2 3/8 in. (31.4 × 24.5 × 6.1 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1966                       Books 442   Metropolitan Museum of Art, New York, NY 1
230059 1970.565.223 0 1 357730 Drawings and Prints 11 Book 97 Gothic Forms Applied to Furniture, Metal Work and Decoration for Domestic Purposes           Designer|Publisher|Lithographer|Lithographer 3533   Bruce J. Talbert|S. Birbeck|S. Ayling|Maclure, Macdonald & Macgregor British, Dundee, Scotland 1838–1881 London|Birmingham, UK|British, active 1860s|London   Talbert, Bruce J.|Birbeck, S.|Ayling, S.|Maclure, Macdonald & Macgregor 30159 British, Scottish|British|British|British 746 1838 |1800 |1860 |1800 1881 |1900 |1869 |1900 1867 1867 1867 Illustrations: photolithography, lithography 36258 18 1/8 x 12 5/8 x 3/8 in. (46 x 32 x 1 cm) Gift of Lincoln Kirstein, 1970                       Books 442   Metropolitan Museum of Art, New York, NY 1
230243 39.44.1 0 0 357929 Drawings and Prints 11 Book 97 The Seasons..with Engraved Illustrations, From Designs Drawn on Wood...And with the Life Of The Author           Author|Author|Editor|Publisher 2132   James Thomson|Patrick Murdoch|Bolton Corney|Longman, Brown, Green and Longmans British, Ednam, Scotland 1700–1748 Richmond-upon-Thames|British, died 1774|British, Thanet 1784–1870 Barnes, Richmond upon Thames|British, London   Thomson, James|Murdoch, Patrick|Corney, Bolton|Longman, Brown, Green and Longmans 30284 British, Scottish|British|British|British 746 1700 |1674 |1784 |1800 1748 |1774 |1870 |1899 1842 1842 1842 Illustrations: engravings 33775 8 7/16 x 6 1/2 in. (21.5 x 16.5 cm) Bequest of Colonel Jacob Ruppert, 1939                       Books 442   Metropolitan Museum of Art, New York, NY 1
249304 43.65.14 0 0 377735 Drawings and Prints 11 Book 97 A Practical Essay on the Art of Colouring and Painting Landscapes in Water Colours           Author|Etcher|Printmaker|Printer 4274   John Heaviside Clark|J. Hamble|Edward Orme|J. Hayes British (born Scotland), 1771–1863 Edinburgh|British, 1790–1807|British, Manchester 1775–1848 London|London   Clark, John Heaviside|Hamble, J.|Orme, Edward|Hayes, J. 35446 British, Scottish|British|British|British 746 1771 |1790 |1775 |1750 1863 |1807 |1848 |1850 1807 1807 1807 Illustrations: aquatint and etching, hand colored with watercolor 39890 15 5/8 x 11 in. (39.7 x 27.9 cm) Harris Brisbane Dick Fund, 1943   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1
415809 41.100.49(2) 0 0 686549 Drawings and Prints 11 Book ; Ornament and Architecture 13814 The New Practical Builder, and Workman's Companion...           Architect|Publisher|Engraver|Engraver 5231   Peter Nicholson|Thomas Kelly|W. Symns|J. Edwards British, Prestonkirk, East Lothian, Scotland 1765–1844 Carlisle, Cumbria|British, active London, ca. 1815–40|British, 19th century|British, active 1820s   Nicholson, Peter|Kelly, Thomas|Symns, W.|Edwards, J. 52716 British, Scottish|British|British|British 746 1765 |1800 |1800 |1800 1844 |1850 |1900 |1850 1823–25 1823 1825 Illustrations: etching and engraving 29021 11 × 8 7/16 × 1 11/16 in. (28 × 21.4 × 4.3 cm) Bequest of W. Gedney Beatty, 1941                       Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 128.531ms · Data license: CC0 · Data source: metmuseum/openaccess